package com.city.repository.party;

import com.city.domain.party.PartyVideo;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * @deprecation: 党建教育视频信息
 * @dmail: 398521613@qq.com
 * @author: L-H
 * @date: 2018-07-18 13:14
 */
public interface PartyVideoRepository extends JpaRepository<PartyVideo,Integer> {

    //通过课程id查找video
    @Query(value = "select * from party_video where lesson_id = ?1",nativeQuery = true)
    List<PartyVideo> findByLessonId(int id);
}
